﻿using gregn6Lib;
using NursingFormSystem.Common;
using NursingFormSystem.Model;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace NursingFormSystem.HealthEducationRecordSheet
{
    public partial class PrintHealthEducationRecordSheet : Form
    {
        #region 变量声明
        private GridppReport Report = new GridppReport();
        NurFormsService.NursingForm formService = new NurFormsService.NursingForm();
        PatientInfo PatientInfo;
        Tb_User LoginUser;
        string Id = string.Empty;
        #endregion

        #region 构造函数
        public PrintHealthEducationRecordSheet(Tb_User loginUser, PatientInfo patientInfo, string id)
        {
            InitializeComponent();
            PatientInfo = patientInfo;
            LoginUser = loginUser;
            this.Id = id;
            //载入报表模板数据
            Report.LoadFromFile(System.Windows.Forms.Application.StartupPath + @"\GRFModel\Ydhl_GRF\健康教育记录单.grf");
            //设置与数据源的连接串，因为在设计时指定的数据库路径是绝对路径。
            Report.ConnectionString = Utility.GetDatabaseConnectionString();
            //连接报表取数事件
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecord);
            //设定查询显示器关联的报表
            axGRPrintViewer1.Report = Report;
        }
        #endregion

        public void ReportFetchRecord()
        {
            var ret = formService.GetNursingFormRecord(PatientInfo.PATIENT_ID, PatientInfo.VISIT_ID, (int)FormType.HealthERecordS);
            DataTable dt = new DataTable();
            if (ret.Code == 1)
            {
                List<NursingFormRecord> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<NursingFormRecord>>(ret.D);
                if (!string.IsNullOrEmpty(this.Id))
                    list = list.Where(p => p.Id.Equals(Convert.ToInt32(this.Id))).ToList();
                CreateDataTableHead(dt);
                for (int i = 0; i < list.Count; i++)
                {
                    NursingFormRecord record = list[i];
                    HealthERS hs = XmlUtil.XMLToObject<HealthERS>(record.NursingFormData, Encoding.UTF8);
                    dt.Rows.Add(
                        PatientInfo.PATIENT_NAME,   //患者姓名
                        PatientInfo.SEX,   //性别
                        PatientInfo.AGE,   //年龄
                        PatientInfo.NURSE_CELL_NAME,   //病区
                        PatientInfo.DEPARTMENT_NAME,    //科室
                        PatientInfo.BED_NO,    //床号
                        PatientInfo.PATIENT_ID,   //住院号
                        hs.RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_ChuCi_RiQi,      //入院_住院环境与须知_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_ChuCi_QianMing,      //入院_住院环境与须知_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_ZaiCi_RiQi,        //入院_住院环境与须知_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_ZaiCi_QianMing,       //入院_住院环境与须知_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,       //入院_住院环境与须知_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_XiaoGuo_QianMing,     //入院_住院环境与须知_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_TanShi_ChuCi_RiQi,              //入院_探视陪伴制度_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_TanShi_ChuCi_QianMing,        //入院_探视陪伴制度_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_TanShi_ZaiCi_RiQi,              //入院_探视陪伴制度_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_TanShi_ZaiCi_QianMing,           //入院_探视陪伴制度_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_TanShi_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_TanShi_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,       //入院_探视陪伴制度_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_TanShi_XiaoGuo_QianMing,           //入院_探视陪伴制度_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_FuZe_ChuCi_RiQi,            //入院_负责的医护人员_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_FuZe_ChuCi_QianMing,      //入院_负责的医护人员_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_FuZe_ZaiCi_RiQi,         //入院_负责的医护人员_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_FuZe_ZaiCi_QianMing,         //入院_负责的医护人员_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_FuZe_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_FuZe_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,   //入院_负责的医护人员_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_FuZe_XiaoGuo_QianMing,         //入院_负责的医护人员_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_BiaoBen_ChuCi_RiQi,           //入院_标本留取方法_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_BiaoBen_ChuCi_QianMing,        //入院_标本留取方法_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_BiaoBen_ZaiCi_RiQi,         //入院_标本留取方法_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_BiaoBen_ZaiCi_QianMing,      //入院_标本留取方法_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_BiaoBen_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_BiaoBen_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,     //入院_标本留取方法_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_BiaoBen_XiaoGuo_QianMing,       //入院_标本留取方法_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_YuFang_ChuCi_RiQi,        //入院_预防跌倒注意事项_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YuFang_ChuCi_QianMing,          //入院_预防跌倒注意事项_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_YuFang_ZaiCi_RiQi,            //入院_预防跌倒注意事项_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YuFang_ZaiCi_QianMing,       //入院_预防跌倒注意事项_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_YuFang_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_YuFang_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,  //入院_预防跌倒注意事项_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_YuFang_XiaoGuo_QianMing,        //入院_预防跌倒注意事项_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_JianCha_ChuCi_RiQi,         //入院_检查注意事项_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_JianCha_ChuCi_QianMing,       //入院_检查注意事项_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_JianCha_ZaiCi_RiQi,         //入院_检查注意事项_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_JianCha_ZaiCi_QianMing,       //入院_检查注意事项_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_JianCha_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_JianCha_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,   //入院_检查注意事项_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_JianCha_XiaoGuo_QianMing,        //入院_检查注意事项_效果评价_签名

                        hs.RuYuanJiaoYu_HuLi_AnQuan_ChuCi_RiQi,         //入院_安全防范措施_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_AnQuan_ChuCi_QianMing,         //入院_安全防范措施_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_AnQuan_ZaiCi_RiQi,          //入院_安全防范措施_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_AnQuan_ZaiCi_QianMing,            //入院_安全防范措施_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_AnQuan_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_AnQuan_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,        //入院_安全防范措施_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_AnQuan_XiaoGuo_QianMing,       //入院_安全防范措施_效果评价_签名

                        hs.RuYuanJiaoYu_HuLi_RuYuan_QiTa_Text,                 //入院_其他_Text
                        hs.RuYuanJiaoYu_HuLi_RuYuan_QiTa_ChuCi_RiQi,        //入院_其他_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_RuYuan_QiTa_ChuCi_QianMing,         //入院_其他_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_RuYuan_QiTa_ZaiCi_RiQi,       //入院_其他_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_RuYuan_QiTa_ZaiCi_QianMing,       //入院_其他_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_RuYuan_QiTa_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_RuYuan_QiTa_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,     //入院_其他_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_RuYuan_QiTa_XiaoGuo_QianMing,        //入院_其他_效果评价_签名

                        hs.ZhuYuanJiaoYu_HuLi_YinShi_ChuCi_RiQi,         //住院_饮食营养知识_初次教育_日期
                        hs.ZhuYuanJiaoYu_HuLi_YinShi_ChuCi_QianMing,          //住院_饮食营养知识_初次教育_签名
                        hs.ZhuYuanJiaoYu_HuLi_YinShi_ZaiCi_RiQi,             //住院_饮食营养知识_再次教育_日期
                        hs.ZhuYuanJiaoYu_HuLi_YinShi_ZaiCi_QianMing,          //住院_饮食营养知识_再次教育_签名
                        !string.IsNullOrEmpty(hs.ZhuYuanJiaoYu_HuLi_YinShi_XiaoGuo_PingJia) ? hs.ZhuYuanJiaoYu_HuLi_YinShi_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,           //住院_饮食营养知识_效果评价_评价
                        hs.ZhuYuanJiaoYu_HuLi_YinShi_XiaoGuo_QianMing,        //住院_饮食营养知识_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_KangFu_ChuCi_RiQi,          //住院_康复知识指导_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_KangFu_ChuCi_QianMing,            //住院_康复知识指导_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_KangFu_ZaiCi_RiQi,          //住院_康复知识指导_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_KangFu_ZaiCi_QianMing,          //住院_康复知识指导_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_KangFu_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_KangFu_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,      //住院_康复知识指导_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_KangFu_XiaoGuo_QianMing,         //住院_康复知识指导_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_YaoWuDeShiYong_ChuCi_RiQi,        //住院_药物的使用方法_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YaoWuDeShiYong_ChuCi_QianMing,    //住院_药物的使用方法_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_YaoWuDeShiYong_ZaiCi_RiQi,        //住院_药物的使用方法_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YaoWuDeShiYong_ZaiCi_QianMing,       //住院_药物的使用方法_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_YaoWuDeShiYong_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_YaoWuDeShiYong_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,      //住院_药物的使用方法_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_YaoWuDeShiYong_XiaoGuo_QianMing,     //住院_药物的使用方法_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_HuXi_ChuCi_RiQi,              //住院_呼吸与咳痰训练_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_HuXi_ChuCi_QianMing,              //住院_呼吸与咳痰训练_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_HuXi_ZaiCi_RiQi,         //住院_呼吸与咳痰训练_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_HuXi_ZaiCi_QianMing,            //住院_呼吸与咳痰训练_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_HuXi_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_HuXi_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,      //住院_呼吸与咳痰训练_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_HuXi_XiaoGuo_QianMing,             //住院_呼吸与咳痰训练_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_YinLiu_ChuCi_RiQi,            //住院_引流管知识指导_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YinLiu_ChuCi_QianMing,           //住院_引流管知识指导_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_YinLiu_ZaiCi_RiQi,             //住院_引流管知识指导_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YinLiu_ZaiCi_QianMing,          //住院_引流管知识指导_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_YinLiu_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_YinLiu_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,      //住院_引流管知识指导_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_YinLiu_XiaoGuo_QianMing,       //住院_引流管知识指导_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_ShuHou_ChuCi_RiQi,             //住院_术后功能训练_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_ShuHou_ChuCi_QianMing,          //住院_术后功能训练_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_ShuHou_ZaiCi_RiQi,              //住院_术后功能训练_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_ShuHou_ZaiCi_QianMing,         //住院_术后功能训练_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_ShuHou_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_ShuHou_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,     //住院_术后功能训练_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_ShuHou_XiaoGuo_QianMing,            //住院_术后功能训练_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_ChuangShang_ChuCi_RiQi,          //住院_床上排泄训练_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_ChuangShang_ChuCi_QianMing,       //住院_床上排泄训练_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_ChuangShang_ZaiCi_RiQi,             //住院_床上排泄训练_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_ChuangShang_ZaiCi_QianMing,       //住院_床上排泄训练_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_ChuangShang_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_ChuangShang_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,   //住院_床上排泄训练_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_ChuangShang_XiaoGuo_QianMing,      //住院_床上排泄训练_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_YaoWuGuoMin_ChuCi_RiQi,       //住院_药物过敏相关知识_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YaoWuGuoMin_ChuCi_QianMing,      //住院_药物过敏相关知识_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_YaoWuGuoMin_ZaiCi_RiQi,           //住院_药物过敏相关知识_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YaoWuGuoMin_ZaiCi_QianMing,         //住院_药物过敏相关知识_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_YaoWuGuoMin_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_YaoWuGuoMin_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,     //住院_药物过敏相关知识_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_YaoWuGuoMin_XiaoGuo_QianMing,        //住院_药物过敏相关知识_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_ShouShu_ChuCi_RiQi,     //住院_手术注意事项_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_ShouShu_ChuCi_QianMing,              //住院_手术注意事项_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_ShouShu_ZaiCi_RiQi,                 //住院_手术注意事项_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_ShouShu_ZaiCi_QianMing,       //住院_手术注意事项_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_ShouShu_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_ShouShu_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,          //住院_手术注意事项_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_ShouShu_XiaoGuo_QianMing,            //住院_手术注意事项_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_YongYang_ChuCi_RiQi,          //住院_用氧安全知识_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YongYang_ChuCi_QianMing,             //住院_用氧安全知识_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_YongYang_ZaiCi_RiQi,                 //住院_用氧安全知识_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_YongYang_ZaiCi_QianMing,           //住院_用氧安全知识_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_YongYang_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_YongYang_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,        //住院_用氧安全知识_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_YongYang_XiaoGuo_QianMing,          //住院_用氧安全知识_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_LiuQu_ChuCi_RiQi,                 //住院_留取标本指导_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_LiuQu_ChuCi_QianMing,            //住院_留取标本指导_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_LiuQu_ZaiCi_RiQi,                 //住院_留取标本指导_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_LiuQu_ZaiCi_QianMing,                 //住院_留取标本指导_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_LiuQu_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_LiuQu_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,       //住院_留取标本指导_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_LiuQu_XiaoGuo_QianMing,          //住院_留取标本指导_效果评价_签名
                        hs.RuYuanJiaoYu_HuLi_QiTa_Text,                        //住院_其他_Text
                        hs.RuYuanJiaoYu_HuLi_QiTa_ChuCi_RiQi,             //住院_其他_初次教育_日期
                        hs.RuYuanJiaoYu_HuLi_QiTa_ChuCi_QianMing,           //住院_其他_初次教育_签名
                        hs.RuYuanJiaoYu_HuLi_QiTa_ZaiCi_RiQi,                    //住院_其他_再次教育_日期
                        hs.RuYuanJiaoYu_HuLi_QiTa_ZaiCi_QianMing,          //住院_其他_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_HuLi_QiTa_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_HuLi_QiTa_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,        //住院_其他_效果评价_评价
                        hs.RuYuanJiaoYu_HuLi_QiTa_XiaoGuo_QianMing,          //住院_其他_效果评价_签名
                        hs.RuYuanJiaoYu_YiLiao_TeShu_ChuCi_RiQi,               //住院_特殊检查配合事项_初次教育_日期
                        hs.RuYuanJiaoYu_YiLiao_TeShu_ChuCi_QianMing,          //住院_特殊检查配合事项_初次教育_签名
                        hs.RuYuanJiaoYu_YiLiao_TeShu_ZaiCi_RiQi,              //住院_特殊检查配合事项_再次教育_日期
                        hs.RuYuanJiaoYu_YiLiao_TeShu_ZaiCi_QianMing,            //住院_特殊检查配合事项_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_YiLiao_TeShu_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_YiLiao_TeShu_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,         //住院_特殊检查配合事项_效果评价_评价
                        hs.RuYuanJiaoYu_YiLiao_TeShu_XiaoGuo_QianMing,         //住院_特殊检查配合事项_效果评价_签名
                        hs.RuYuanJiaoYu_YiLiao_ShouShu_ChuCi_RiQi,             //住院_手术、麻醉知识_初次教育_日期
                        hs.RuYuanJiaoYu_YiLiao_ShouShu_ChuCi_QianMing,           //住院_手术、麻醉知识_初次教育_签名
                        hs.RuYuanJiaoYu_YiLiao_ShouShu_ZaiCi_RiQi,          //住院_手术、麻醉知识_再次教育_日期
                        hs.RuYuanJiaoYu_YiLiao_ShouShu_ZaiCi_QianMing,          //住院_手术、麻醉知识_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_YiLiao_ShouShu_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_YiLiao_ShouShu_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,       //住院_手术、麻醉知识_效果评价_评价
                        hs.RuYuanJiaoYu_YiLiao_ShouShu_XiaoGuo_QianMing,          //住院_手术、麻醉知识_效果评价_签名
                        hs.RuYuanJiaoYu_YiLiao_TengTongZhi_ChuCi_RiQi,           //住院_疼痛知识及处理_初次教育_日期
                        hs.RuYuanJiaoYu_YiLiao_TengTongZhi_ChuCi_QianMing,         //住院_疼痛知识及处理_初次教育_签名
                        hs.RuYuanJiaoYu_YiLiao_TengTongZhi_ZaiCi_RiQi,             //住院_疼痛知识及处理_再次教育_日期
                        hs.RuYuanJiaoYu_YiLiao_TengTongZhi_ZaiCi_QianMing,         //住院_疼痛知识及处理_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_YiLiao_TengTongZhi_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_YiLiao_TengTongZhi_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,      //住院_疼痛知识及处理_效果评价_评价
                        hs.RuYuanJiaoYu_YiLiao_TengTongZhi_XiaoGuo_QianMing,       //住院_疼痛知识及处理_效果评价_签名
                        hs.RuYuanJiaoYu_YiLiao_QiTa_Text,                         //住院_其他_Text
                        hs.RuYuanJiaoYu_YiLiao_QiTa_ChuCi_RiQi,                     //住院_其他_初次教育_日期
                        hs.RuYuanJiaoYu_YiLiao_QiTa_ChuCi_QianMing,                //住院_其他_初次教育_签名
                        hs.RuYuanJiaoYu_YiLiao_QiTa_ZaiCi_RiQi,                      //住院_其他_再次教育_日期
                        hs.RuYuanJiaoYu_YiLiao_QiTa_ZaiCi_QianMing,                  //住院_其他_再次教育_签名
                        !string.IsNullOrEmpty(hs.RuYuanJiaoYu_YiLiao_QiTa_XiaoGuo_PingJia) ? hs.RuYuanJiaoYu_YiLiao_QiTa_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,               //住院_其他_效果评价_评价
                        hs.RuYuanJiaoYu__YiLiao_QiTa_XiaoGuo_QianMing,                //住院_其他_效果评价_签名
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_ChuCi_RiQi,         //出院_出院流程_初次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_ChuCi_QianMing,           //出院_出院流程_初次教育_签名
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_ZaiCi_RiQi,              //出院_出院流程_再次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_ZaiCi_QianMing,           //出院_出院流程_再次教育_签名
                        !string.IsNullOrEmpty(hs.ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_XiaoGuo_PingJia) ? hs.ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,         //出院_出院流程_效果评价_评价
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_XiaoGuo_QianMing,        //出院_出院流程_效果评价_签名
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanYongYao_ChuCi_RiQi,             //出院_出院用药知识_初次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanYongYao_ChuCi_QianMing,             //出院_出院用药知识_初次教育_签名
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanYongYao_ZaiCi_RiQi,                 //出院_出院用药知识_再次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanYongYao_ZaiCi_QianMing,           //出院_出院用药知识_再次教育_签名
                        !string.IsNullOrEmpty(hs.ChuYuanJiaoYu_HuLi_ChuYuanYongYao_XiaoGuo_PingJia) ? hs.ChuYuanJiaoYu_HuLi_ChuYuanYongYao_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,          //出院_出院用药知识_效果评价_评价
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanYongYao_XiaoGuo_QianMing,         //出院_出院用药知识_效果评价_签名
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_ChuCi_RiQi,             //出院_出院随访复诊须知_初次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_ChuCi_QianMing,         //出院_出院随访复诊须知_初次教育_签名
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_ZaiCi_RiQi,             //出院_出院随访复诊须知_再次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_ZaiCi_QianMing,       //出院_出院随访复诊须知_再次教育_签名
                        !string.IsNullOrEmpty(hs.ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_XiaoGuo_PingJia) ? hs.ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,       //出院_出院随访复诊须知_效果评价_评价
                        hs.ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_XiaoGuo_QianMing,          //出院_出院随访复诊须知_效果评价_签名
                        hs.ChuYuanJiaoYu_HuLi_YinShi_ChuCi_RiQi,                  //出院_饮食营养知识_初次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_YinShi_ChuCi_QianMing,              //出院_饮食营养知识_初次教育_签名
                        hs.ChuYuanJiaoYu_HuLi_YinShi_ZaiCi_RiQi,                 //出院_饮食营养知识_再次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_YinShi_ZaiCi_QianMing,           //出院_饮食营养知识_再次教育_签名
                        !string.IsNullOrEmpty(hs.ChuYuanJiaoYu_HuLi_YinShi_XiaoGuo_PingJia) ? hs.ChuYuanJiaoYu_HuLi_YinShi_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,            //出院_饮食营养知识_效果评价_评价
                        hs.ChuYuanJiaoYu_HuLi_YinShi_XiaoGuo_QianMing,               //出院_饮食营养知识_效果评价_签名
                        hs.ChuYuanJiaoYu_HuLi_KangFu_ChuCi_RiQi,              //出院_康复知识_初次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_KangFu_ChuCi_QianMing,           //出院_康复知识_初次教育_签名
                        hs.ChuYuanJiaoYu_HuLi_KangFu_ZaiCi_RiQi,                //出院_康复知识_再次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_KangFu_ZaiCi_QianMing,                //出院_康复知识_再次教育_签名
                        !string.IsNullOrEmpty(hs.ChuYuanJiaoYu_HuLi_KangFu_XiaoGuo_PingJia) ? hs.ChuYuanJiaoYu_HuLi_KangFu_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,            //出院_康复知识_效果评价_评价
                        hs.ChuYuanJiaoYu_HuLi_KangFu_XiaoGuo_QianMing,            //出院_康复知识_效果评价_签名
                        hs.ChuYuanJiaoYu_HuLi_TiNei_ChuCi_RiQi,             //出院_体内留置物知识_初次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_TiNei_ChuCi_QianMing,           //出院_体内留置物知识_初次教育_签名
                        hs.ChuYuanJiaoYu_HuLi_TiNei_ZaiCi_RiQi,               //出院_体内留置物知识_再次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_TiNei_ZaiCi_QianMing,             //出院_体内留置物知识_再次教育_签名
                        !string.IsNullOrEmpty(hs.ChuYuanJiaoYu_HuLi_TiNei_XiaoGuo_PingJia) ? hs.ChuYuanJiaoYu_HuLi_TiNei_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,         //出院_体内留置物知识_效果评价_评价
                        hs.ChuYuanJiaoYu_HuLi_TiNei_XiaoGuo_QianMing,          //出院_体内留置物知识_效果评价_签名
                        hs.ChuYuanJiaoYu_HuLi_GongNeng_ChuCi_RiQi,            //出院_功能锻炼方法_初次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_GongNeng_ChuCi_QianMing,          //出院_功能锻炼方法_初次教育_签名
                        hs.ChuYuanJiaoYu_HuLi_GongNeng_ZaiCi_RiQi,                  //出院_功能锻炼方法_再次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_GongNeng_ZaiCi_QianMing,                  //出院_功能锻炼方法_再次教育_签名
                        !string.IsNullOrEmpty(hs.ChuYuanJiaoYu_HuLi_GongNeng_XiaoGuo_PingJia) ? hs.ChuYuanJiaoYu_HuLi_GongNeng_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,             //出院_功能锻炼方法_效果评价_评价
                        hs.ChuYuanJiaoYu_HuLi_GongNeng_XiaoGuo_QianMing,           //出院_功能锻炼方法_效果评价_签名
                        hs.ChuYuanJiaoYu_HuLi_TengTong_ChuCi_RiQi,         //出院_疼痛知识及处理_初次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_TengTong_ChuCi_QianMing,           //出院_疼痛知识及处理_初次教育_签名
                        hs.ChuYuanJiaoYu_HuLi_TengTong_ZaiCi_RiQi,            //出院_疼痛知识及处理_再次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_TengTong_ZaiCi_QianMing,         //出院_疼痛知识及处理_再次教育_签名
                        !string.IsNullOrEmpty(hs.ChuYuanJiaoYu_HuLi_TengTong_XiaoGuo_PingJia) ? hs.ChuYuanJiaoYu_HuLi_TengTong_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,          //出院_疼痛知识及处理_效果评价_评价
                        hs.ChuYuanJiaoYu_HuLi_TengTong_XiaoGuo_QianMing,            //出院_疼痛知识及处理_效果评价_签名
                        hs.ChuYuanJiaoYu_HuLi_QiTa_Text,                    //住院_其他_Text
                        hs.ChuYuanJiaoYu_HuLi_QiTa_ChuCi_RiQi,                  //住院_其他_初次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_QiTa_ChuCi_QianMing,            //住院_其他_初次教育_签名
                        hs.ChuYuanJiaoYu_HuLi_QiTa_ZaiCi_RiQi,           //住院_其他_再次教育_日期
                        hs.ChuYuanJiaoYu_HuLi_QiTa_ZaiCi_QianMing,           //住院_其他_再次教育_签名
                        !string.IsNullOrEmpty(hs.ChuYuanJiaoYu_HuLi_QiTa_XiaoGuo_PingJia) ? hs.ChuYuanJiaoYu_HuLi_QiTa_XiaoGuo_PingJia.Substring(0, 1) : string.Empty,       //住院_其他_效果评价_评价
                        hs.ChuYuanJiaoYu_HuLi_QiTa_XiaoGuo_QianMing       //住院_其他_效果评价_签名

                        );
                }
                Utility.FillRecordToReport(Report, dt);
            }
            else if (ret.Code == 2)
            {
                CreateDataTableHead(dt);
                DataRow dr = dt.NewRow();
                dt.Rows.Add(dr);
                Utility.FillRecordToReport(Report, dt);
            }
            else if (ret.Code == 0)
            {
                MessageBox.Show(ret.M);
            }
        }


        /// <summary>
        /// 加载列头
        /// </summary>
        /// <param name="dt"></param>
        private void CreateDataTableHead(DataTable dt)
        {
            dt.Columns.Add("PATIENT_NAME", typeof(string));
            dt.Columns.Add("SEX", typeof(string));
            dt.Columns.Add("Age", typeof(string));
            dt.Columns.Add("NURSE_CELL_NAME", typeof(string));
            dt.Columns.Add("DEPARTMENT_NAME", typeof(string));
            dt.Columns.Add("BED_NO", typeof(string));
            dt.Columns.Add("PATIENT_ID", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ZhuYuanHuanJing_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_TanShi_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_TanShi_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_TanShi_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_TanShi_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_TanShi_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_TanShi_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_FuZe_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_FuZe_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_FuZe_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_FuZe_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_FuZe_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_FuZe_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_BiaoBen_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_BiaoBen_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_BiaoBen_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_BiaoBen_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_BiaoBen_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_BiaoBen_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YuFang_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YuFang_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YuFang_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YuFang_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YuFang_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YuFang_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_JianCha_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_JianCha_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_JianCha_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_JianCha_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_JianCha_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_JianCha_XiaoGuo_QianMing", typeof(string));


            dt.Columns.Add("RuYuanJiaoYu_HuLi_AnQuan_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_AnQuan_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_AnQuan_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_AnQuan_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_AnQuan_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_AnQuan_XiaoGuo_QianMing", typeof(string));

            dt.Columns.Add("RuYuanJiaoYu_HuLi_RuYuan_QiTa_Text", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_RuYuan_QiTa_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_RuYuan_QiTa_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_RuYuan_QiTa_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_RuYuan_QiTa_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_RuYuan_QiTa_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_RuYuan_QiTa_XiaoGuo_QianMing", typeof(string));

            dt.Columns.Add("ZhuYuanJiaoYu_HuLi_YinShi_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ZhuYuanJiaoYu_HuLi_YinShi_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ZhuYuanJiaoYu_HuLi_YinShi_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ZhuYuanJiaoYu_HuLi_YinShi_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ZhuYuanJiaoYu_HuLi_YinShi_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ZhuYuanJiaoYu_HuLi_YinShi_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_KangFu_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_KangFu_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_KangFu_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_KangFu_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_KangFu_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_KangFu_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuDeShiYong_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuDeShiYong_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuDeShiYong_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuDeShiYong_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuDeShiYong_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuDeShiYong_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_HuXi_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_HuXi_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_HuXi_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_HuXi_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_HuXi_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_HuXi_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YinLiu_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YinLiu_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YinLiu_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YinLiu_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YinLiu_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YinLiu_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShuHou_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShuHou_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShuHou_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShuHou_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShuHou_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShuHou_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ChuangShang_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ChuangShang_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ChuangShang_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ChuangShang_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ChuangShang_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ChuangShang_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuGuoMin_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuGuoMin_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuGuoMin_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuGuoMin_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuGuoMin_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YaoWuGuoMin_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShouShu_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShouShu_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShouShu_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShouShu_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShouShu_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_ShouShu_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YongYang_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YongYang_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YongYang_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YongYang_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YongYang_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_YongYang_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_LiuQu_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_LiuQu_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_LiuQu_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_LiuQu_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_LiuQu_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_LiuQu_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_QiTa_Text", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_QiTa_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_QiTa_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_QiTa_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_QiTa_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_QiTa_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_HuLi_QiTa_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TeShu_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TeShu_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TeShu_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TeShu_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TeShu_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TeShu_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_ShouShu_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_ShouShu_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_ShouShu_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_ShouShu_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_ShouShu_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_ShouShu_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TengTongZhi_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TengTongZhi_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TengTongZhi_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TengTongZhi_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TengTongZhi_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_TengTongZhi_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_QiTa_Text", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_QiTa_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_QiTa_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_QiTa_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_QiTa_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu_YiLiao_QiTa_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("RuYuanJiaoYu__YiLiao_QiTa_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanLiuCheng_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanYongYao_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanYongYao_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanYongYao_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanYongYao_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanYongYao_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanYongYao_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_ChuYuanSuiFang_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_YinShi_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_YinShi_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_YinShi_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_YinShi_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_YinShi_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_YinShi_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_KangFu_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_KangFu_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_KangFu_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_KangFu_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_KangFu_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_KangFu_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TiNei_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TiNei_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TiNei_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TiNei_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TiNei_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TiNei_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_GongNeng_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_GongNeng_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_GongNeng_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_GongNeng_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_GongNeng_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_GongNeng_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TengTong_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TengTong_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TengTong_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TengTong_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TengTong_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_TengTong_XiaoGuo_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_QiTa_Text", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_QiTa_ChuCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_QiTa_ChuCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_QiTa_ZaiCi_RiQi", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_QiTa_ZaiCi_QianMing", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_QiTa_XiaoGuo_PingJia", typeof(string));
            dt.Columns.Add("ChuYuanJiaoYu_HuLi_QiTa_XiaoGuo_QianMing", typeof(string));

        }


        private void PrintHealthEducationRecordSheet_Load(object sender, EventArgs e)
        {
            axGRPrintViewer1.Start();
        }

    }
}
